Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 3989 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 596.1 KiB |
| Average record size in memory | 153.0 B |
Variable types
| Text | 3 |
|---|---|
| Numeric | 4 |
| Categorical | 11 |
| DateTime | 1 |
| Boolean | 1 |
card_number is highly overall correlated with customer_segment and 3 other fields | High correlation |
trans_amount is highly overall correlated with fake | High correlation |
customer_segment is highly overall correlated with card_number | High correlation |
card_type is highly overall correlated with card_number | High correlation |
customer_location is highly overall correlated with card_number and 1 other fields | High correlation |
merchant_name is highly overall correlated with fake | High correlation |
trans_loc is highly overall correlated with card_number and 1 other fields | High correlation |
trans_currency is highly overall correlated with fake | High correlation |
fake is highly overall correlated with trans_amount and 2 other fields | High correlation |
trans_currency is highly imbalanced (59.1%) | Imbalance |
trans_id has unique values | Unique |
trans_approval_code has unique values | Unique |
Reproduction
| Analysis started | 2023-09-09 00:23:31.840181 |
|---|---|
| Analysis finished | 2023-09-09 00:25:40.509862 |
| Duration | 2 minutes and 8.67 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
cardholder_name
Text
| Distinct | 988 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 21 |
| Mean length | 13.177488 |
| Min length | 8 |
Characters and Unicode
| Total characters | 52565 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Eric Scott |
|---|---|
| 2nd row | Eric Scott |
| 3rd row | Eric Scott |
| 4th row | Jason Jacobs |
| 5th row | Jason Jacobs |
| Value | Count | Frequency (%) |
| smith | 105 | 1.3% |
| michael | 87 | 1.1% |
| thomas | 81 | 1.0% |
| john | 71 | 0.9% |
| johnson | 62 | 0.8% |
| david | 59 | 0.7% |
| jessica | 59 | 0.7% |
| kevin | 58 | 0.7% |
| brown | 55 | 0.7% |
| wilson | 54 | 0.7% |
| Other values (810) | 7440 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4932 | 9.4% |
| a | 4770 | 9.1% |
| 4142 | 7.9% | |
| n | 3922 | 7.5% |
| r | 3795 | 7.2% |
| i | 3063 | 5.8% |
| o | 2909 | 5.5% |
| l | 2489 | 4.7% |
| s | 2433 | 4.6% |
| t | 2006 | 3.8% |
| Other values (43) | 18104 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 40104 | |
| Uppercase Letter | 8253 | 15.7% |
| Space Separator | 4142 | 7.9% |
| Other Punctuation | 66 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4932 | |
| a | 4770 | |
| n | 3922 | |
| r | 3795 | |
| i | 3063 | 7.6% |
| o | 2909 | 7.3% |
| l | 2489 | 6.2% |
| s | 2433 | 6.1% |
| t | 2006 | 5.0% |
| h | 1808 | 4.5% |
| Other values (16) | 7977 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 908 | 11.0% |
| J | 777 | 9.4% |
| C | 621 | 7.5% |
| S | 609 | 7.4% |
| D | 563 | 6.8% |
| R | 501 | 6.1% |
| B | 481 | 5.8% |
| A | 456 | 5.5% |
| W | 438 | 5.3% |
| H | 418 | 5.1% |
| Other values (15) | 2481 |
Space Separator
| Value | Count | Frequency (%) |
| 4142 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 66 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 48357 | |
| Common | 4208 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4932 | 10.2% |
| a | 4770 | 9.9% |
| n | 3922 | 8.1% |
| r | 3795 | 7.8% |
| i | 3063 | 6.3% |
| o | 2909 | 6.0% |
| l | 2489 | 5.1% |
| s | 2433 | 5.0% |
| t | 2006 | 4.1% |
| h | 1808 | 3.7% |
| Other values (41) | 16230 |
Common
| Value | Count | Frequency (%) |
| 4142 | ||
| . | 66 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 52565 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 4932 | 9.4% |
| a | 4770 | 9.1% |
| 4142 | 7.9% | |
| n | 3922 | 7.5% |
| r | 3795 | 7.2% |
| i | 3063 | 5.8% |
| o | 2909 | 5.5% |
| l | 2489 | 4.7% |
| s | 2433 | 4.6% |
| t | 2006 | 3.8% |
| Other values (43) | 18104 |
card_number
Real number (ℝ)
HIGH CORRELATION
| Distinct | 1000 |
|---|---|
| Distinct (%) | 25.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.900998 × 1011 |
| Minimum | 8.9289214 × 108 |
|---|---|
| Maximum | 9.9906721 × 1011 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.3 KiB |
Quantile statistics
| Minimum | 8.9289214 × 108 |
|---|---|
| 5-th percentile | 4.1944075 × 1010 |
| Q1 | 2.4409851 × 1011 |
| median | 5.0215155 × 1011 |
| Q3 | 7.418035 × 1011 |
| 95-th percentile | 9.5200944 × 1011 |
| Maximum | 9.9906721 × 1011 |
| Range | 9.9817432 × 1011 |
| Interquartile range (IQR) | 4.9770499 × 1011 |
Descriptive statistics
| Standard deviation | 2.9035767 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.59244602 |
| Kurtosis | -1.1794322 |
| Mean | 4.900998 × 1011 |
| Median Absolute Deviation (MAD) | 2.4521463 × 1011 |
| Skewness | 0.0084910101 |
| Sum | 1.9550081 × 1015 |
| Variance | 8.4307578 × 1022 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.855854116 × 1011 | 6 | 0.2% |
| 6.35897845 × 1011 | 6 | 0.2% |
| 6.436706811 × 1010 | 6 | 0.2% |
| 5.983606543 × 1011 | 6 | 0.2% |
| 1.372442549 × 1011 | 6 | 0.2% |
| 7.406717455 × 1010 | 6 | 0.2% |
| 9.292827794 × 1011 | 6 | 0.2% |
| 3.606326657 × 1011 | 6 | 0.2% |
| 1.496986148 × 1011 | 6 | 0.2% |
| 7.163525352 × 1010 | 6 | 0.2% |
| Other values (990) | 3929 |
| Value | Count | Frequency (%) |
| 892892140 | 6 | |
| 1582283666 | 2 | 0.1% |
| 2265677629 | 4 | |
| 2603340564 | 4 | |
| 5753444808 | 6 | |
| 6187905742 | 3 | |
| 7026605966 | 2 | 0.1% |
| 7828017180 | 4 | |
| 8234714276 | 4 | |
| 1.03752441 × 1010 | 4 |
| Value | Count | Frequency (%) |
| 9.990672138 × 1011 | 5 | |
| 9.984902805 × 1011 | 5 | |
| 9.963276358 × 1011 | 3 | |
| 9.950976328 × 1011 | 2 | 0.1% |
| 9.942390924 × 1011 | 5 | |
| 9.935287527 × 1011 | 4 | |
| 9.932618476 × 1011 | 4 | |
| 9.922829315 × 1011 | 6 | |
| 9.894241454 × 1011 | 2 | 0.1% |
| 9.891618558 × 1011 | 5 |
customer_age
Real number (ℝ)
| Distinct | 49 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.488594 |
| Minimum | 18 |
|---|---|
| Maximum | 69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.3 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 28 |
| median | 40 |
| Q3 | 51 |
| 95-th percentile | 68 |
| Maximum | 69 |
| Range | 51 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 14.67239 |
|---|---|
| Coefficient of variation (CV) | 0.35364876 |
| Kurtosis | -0.98914252 |
| Mean | 41.488594 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.28548129 |
| Sum | 165498 |
| Variance | 215.27902 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) |
| 39 | 197 | 4.9% |
| 45 | 194 | 4.9% |
| 43 | 177 | 4.4% |
| 37 | 162 | 4.1% |
| 22 | 156 | 3.9% |
| 24 | 145 | 3.6% |
| 20 | 144 | 3.6% |
| 25 | 143 | 3.6% |
| 32 | 137 | 3.4% |
| 55 | 123 | 3.1% |
| Other values (39) | 2411 |
| Value | Count | Frequency (%) |
| 18 | 29 | 0.7% |
| 19 | 64 | |
| 20 | 144 | |
| 21 | 22 | 0.6% |
| 22 | 156 | |
| 23 | 37 | 0.9% |
| 24 | 145 | |
| 25 | 143 | |
| 26 | 85 | |
| 27 | 120 |
| Value | Count | Frequency (%) |
| 69 | 95 | |
| 68 | 120 | |
| 67 | 57 | |
| 66 | 33 | 0.8% |
| 65 | 85 | |
| 64 | 108 | |
| 63 | 9 | 0.2% |
| 62 | 46 | 1.2% |
| 61 | 7 | 0.2% |
| 60 | 77 |
customer_segment
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Student | |
|---|---|
| Retail | |
| Premium | |
| Business | |
| Other |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.6036601 |
| Min length | 5 |
Characters and Unicode
| Total characters | 26342 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Retail |
|---|---|
| 2nd row | Retail |
| 3rd row | Retail |
| 4th row | Student |
| 5th row | Student |
Common Values
| Value | Count | Frequency (%) |
| Student | 847 | |
| Retail | 809 | |
| Premium | 780 | |
| Business | 778 | |
| Other | 775 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| student | 847 | |
| retail | 809 | |
| premium | 780 | |
| business | 778 | |
| other | 775 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3989 | |
| t | 3278 | |
| u | 2405 | |
| i | 2367 | |
| s | 2334 | |
| n | 1625 | 6.2% |
| m | 1560 | 5.9% |
| r | 1555 | 5.9% |
| S | 847 | 3.2% |
| d | 847 | 3.2% |
| Other values (7) | 5535 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 22353 | |
| Uppercase Letter | 3989 | 15.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3989 | |
| t | 3278 | |
| u | 2405 | |
| i | 2367 | |
| s | 2334 | |
| n | 1625 | |
| m | 1560 | 7.0% |
| r | 1555 | 7.0% |
| d | 847 | 3.8% |
| l | 809 | 3.6% |
| Other values (2) | 1584 | 7.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 847 | |
| R | 809 | |
| P | 780 | |
| B | 778 | |
| O | 775 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 26342 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3989 | |
| t | 3278 | |
| u | 2405 | |
| i | 2367 | |
| s | 2334 | |
| n | 1625 | 6.2% |
| m | 1560 | 5.9% |
| r | 1555 | 5.9% |
| S | 847 | 3.2% |
| d | 847 | 3.2% |
| Other values (7) | 5535 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26342 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 3989 | |
| t | 3278 | |
| u | 2405 | |
| i | 2367 | |
| s | 2334 | |
| n | 1625 | 6.2% |
| m | 1560 | 5.9% |
| r | 1555 | 5.9% |
| S | 847 | 3.2% |
| d | 847 | 3.2% |
| Other values (7) | 5535 |
card_type
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Visa | |
|---|---|
| Rupay | |
| Other | |
| American Express | |
| MasterCard |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 7.8177488 |
| Min length | 4 |
Characters and Unicode
| Total characters | 31185 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Other |
|---|---|
| 2nd row | Other |
| 3rd row | Other |
| 4th row | Visa |
| 5th row | Visa |
Common Values
| Value | Count | Frequency (%) |
| Visa | 865 | |
| Rupay | 847 | |
| Other | 768 | |
| American Express | 760 | |
| MasterCard | 749 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| visa | 865 | |
| rupay | 847 | |
| other | 768 | |
| american | 760 | |
| express | 760 | |
| mastercard | 749 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3970 | 12.7% |
| r | 3786 | 12.1% |
| s | 3134 | 10.0% |
| e | 3037 | 9.7% |
| i | 1625 | 5.2% |
| p | 1607 | 5.2% |
| t | 1517 | 4.9% |
| V | 865 | 2.8% |
| y | 847 | 2.7% |
| u | 847 | 2.7% |
| Other values (13) | 9950 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 24927 | |
| Uppercase Letter | 5498 | 17.6% |
| Space Separator | 760 | 2.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3970 | |
| r | 3786 | |
| s | 3134 | |
| e | 3037 | |
| i | 1625 | |
| p | 1607 | |
| t | 1517 | 6.1% |
| y | 847 | 3.4% |
| u | 847 | 3.4% |
| h | 768 | 3.1% |
| Other values (5) | 3789 |
Uppercase Letter
| Value | Count | Frequency (%) |
| V | 865 | |
| R | 847 | |
| O | 768 | |
| A | 760 | |
| E | 760 | |
| M | 749 | |
| C | 749 |
Space Separator
| Value | Count | Frequency (%) |
| 760 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 30425 | |
| Common | 760 | 2.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3970 | |
| r | 3786 | |
| s | 3134 | 10.3% |
| e | 3037 | 10.0% |
| i | 1625 | 5.3% |
| p | 1607 | 5.3% |
| t | 1517 | 5.0% |
| V | 865 | 2.8% |
| y | 847 | 2.8% |
| u | 847 | 2.8% |
| Other values (12) | 9190 |
Common
| Value | Count | Frequency (%) |
| 760 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31185 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 3970 | 12.7% |
| r | 3786 | 12.1% |
| s | 3134 | 10.0% |
| e | 3037 | 9.7% |
| i | 1625 | 5.2% |
| p | 1607 | 5.2% |
| t | 1517 | 4.9% |
| V | 865 | 2.8% |
| y | 847 | 2.7% |
| u | 847 | 2.7% |
| Other values (13) | 9950 |
customer_location
Categorical
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Delhi | |
|---|---|
| Lucknow | |
| Mumbai | |
| Ahmedabad | |
| Pune | |
| Other values (5) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.8540988 |
| Min length | 4 |
Characters and Unicode
| Total characters | 27341 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kolkata |
|---|---|
| 2nd row | Kolkata |
| 3rd row | Kolkata |
| 4th row | Delhi |
| 5th row | Delhi |
Common Values
| Value | Count | Frequency (%) |
| Delhi | 447 | |
| Lucknow | 447 | |
| Mumbai | 413 | |
| Ahmedabad | 410 | |
| Pune | 406 | |
| Kolkata | 385 | |
| Bangalore | 378 | |
| Jaipur | 377 | |
| Hyderabad | 372 | |
| Chennai | 354 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| delhi | 447 | |
| lucknow | 447 | |
| mumbai | 413 | |
| ahmedabad | 410 | |
| pune | 406 | |
| kolkata | 385 | |
| bangalore | 378 | |
| jaipur | 377 | |
| hyderabad | 372 | |
| chennai | 354 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | 8.7% |
| n | 1939 | 7.1% |
| u | 1643 | 6.0% |
| i | 1591 | 5.8% |
| d | 1564 | 5.7% |
| h | 1211 | 4.4% |
| l | 1210 | 4.4% |
| o | 1210 | 4.4% |
| b | 1195 | 4.4% |
| Other values (19) | 9177 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 23352 | |
| Uppercase Letter | 3989 | 14.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | |
| n | 1939 | 8.3% |
| u | 1643 | 7.0% |
| i | 1591 | 6.8% |
| d | 1564 | 6.7% |
| h | 1211 | 5.2% |
| l | 1210 | 5.2% |
| o | 1210 | 5.2% |
| b | 1195 | 5.1% |
| Other values (9) | 5188 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 447 | |
| L | 447 | |
| M | 413 | |
| A | 410 | |
| P | 406 | |
| K | 385 | |
| B | 378 | |
| J | 377 | |
| H | 372 | |
| C | 354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27341 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | 8.7% |
| n | 1939 | 7.1% |
| u | 1643 | 6.0% |
| i | 1591 | 5.8% |
| d | 1564 | 5.7% |
| h | 1211 | 4.4% |
| l | 1210 | 4.4% |
| o | 1210 | 4.4% |
| b | 1195 | 4.4% |
| Other values (19) | 9177 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27341 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | 8.7% |
| n | 1939 | 7.1% |
| u | 1643 | 6.0% |
| i | 1591 | 5.8% |
| d | 1564 | 5.7% |
| h | 1211 | 4.4% |
| l | 1210 | 4.4% |
| o | 1210 | 4.4% |
| b | 1195 | 4.4% |
| Other values (19) | 9177 |
merchant_name
Categorical
HIGH CORRELATION
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| amazon gift cards | |
|---|---|
| instamart | |
| airtel | |
| swiggy | |
| amazon | |
| Other values (13) |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 9.6269742 |
| Min length | 6 |
Characters and Unicode
| Total characters | 38402 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | airtel |
|---|---|
| 2nd row | airtel |
| 3rd row | fake_merchant_8 |
| 4th row | rakuten |
| 5th row | swiggy |
Common Values
| Value | Count | Frequency (%) |
| amazon gift cards | 419 | |
| instamart | 418 | |
| airtel | 417 | |
| swiggy | 408 | |
| amazon | 405 | |
| rakuten | 402 | |
| zomato | 393 | |
| chai talks | 388 | |
| fake_merchant_0 | 87 | 2.2% |
| fake_merchant_4 | 82 | 2.1% |
| Other values (8) | 570 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| amazon | 824 | |
| gift | 419 | |
| cards | 419 | |
| instamart | 418 | |
| airtel | 417 | |
| swiggy | 408 | |
| rakuten | 402 | |
| zomato | 393 | |
| chai | 388 | |
| talks | 388 | |
| Other values (10) | 739 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6369 | |
| t | 3594 | 9.4% |
| r | 2395 | 6.2% |
| n | 2383 | 6.2% |
| m | 2374 | 6.2% |
| e | 2297 | 6.0% |
| i | 2050 | 5.3% |
| s | 1633 | 4.3% |
| o | 1610 | 4.2% |
| c | 1546 | 4.0% |
| Other values (22) | 12151 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 34959 | |
| Connector Punctuation | 1478 | 3.8% |
| Space Separator | 1226 | 3.2% |
| Decimal Number | 739 | 1.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6369 | |
| t | 3594 | |
| r | 2395 | 6.9% |
| n | 2383 | 6.8% |
| m | 2374 | 6.8% |
| e | 2297 | 6.6% |
| i | 2050 | 5.9% |
| s | 1633 | 4.7% |
| o | 1610 | 4.6% |
| c | 1546 | 4.4% |
| Other values (10) | 8708 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 87 | |
| 4 | 82 | |
| 2 | 80 | |
| 1 | 77 | |
| 9 | 75 | |
| 7 | 72 | |
| 5 | 72 | |
| 8 | 70 | |
| 6 | 65 | |
| 3 | 59 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1478 |
Space Separator
| Value | Count | Frequency (%) |
| 1226 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 34959 | |
| Common | 3443 | 9.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6369 | |
| t | 3594 | |
| r | 2395 | 6.9% |
| n | 2383 | 6.8% |
| m | 2374 | 6.8% |
| e | 2297 | 6.6% |
| i | 2050 | 5.9% |
| s | 1633 | 4.7% |
| o | 1610 | 4.6% |
| c | 1546 | 4.4% |
| Other values (10) | 8708 |
Common
| Value | Count | Frequency (%) |
| _ | 1478 | |
| 1226 | ||
| 0 | 87 | 2.5% |
| 4 | 82 | 2.4% |
| 2 | 80 | 2.3% |
| 1 | 77 | 2.2% |
| 9 | 75 | 2.2% |
| 7 | 72 | 2.1% |
| 5 | 72 | 2.1% |
| 8 | 70 | 2.0% |
| Other values (2) | 124 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38402 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6369 | |
| t | 3594 | 9.4% |
| r | 2395 | 6.2% |
| n | 2383 | 6.2% |
| m | 2374 | 6.2% |
| e | 2297 | 6.0% |
| i | 2050 | 5.3% |
| s | 1633 | 4.3% |
| o | 1610 | 4.2% |
| c | 1546 | 4.0% |
| Other values (22) | 12151 |
merchant_location
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Lucknow | 228 |
|---|---|
| New York City, USA | 224 |
| Hyderabad | 219 |
| Tokyo, Japan | 215 |
| Singapore, Singapore | 215 |
| Other values (15) |
Length
| Max length | 23 |
|---|---|
| Median length | 17 |
| Mean length | 11.666082 |
| Min length | 4 |
Characters and Unicode
| Total characters | 46536 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Tokyo, Japan |
|---|---|
| 2nd row | Cape Town, South Africa |
| 3rd row | New York City, USA |
| 4th row | Chennai |
| 5th row | Chennai |
Common Values
| Value | Count | Frequency (%) |
| Lucknow | 228 | 5.7% |
| New York City, USA | 224 | 5.6% |
| Hyderabad | 219 | 5.5% |
| Tokyo, Japan | 215 | 5.4% |
| Singapore, Singapore | 215 | 5.4% |
| Bangalore | 215 | 5.4% |
| Cape Town, South Africa | 213 | 5.3% |
| Rio de Janeiro, Brazil | 211 | 5.3% |
| Toronto, Canada | 207 | 5.2% |
| Paris, France | 204 | 5.1% |
| Other values (10) | 1838 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| singapore | 430 | 5.9% |
| lucknow | 228 | 3.1% |
| york | 224 | 3.1% |
| city | 224 | 3.1% |
| usa | 224 | 3.1% |
| new | 224 | 3.1% |
| hyderabad | 219 | 3.0% |
| tokyo | 215 | 2.9% |
| japan | 215 | 2.9% |
| bangalore | 215 | 2.9% |
| Other values (25) | 4915 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5410 | 11.6% |
| o | 3536 | 7.6% |
| 3344 | 7.2% | |
| n | 3238 | 7.0% |
| e | 2840 | 6.1% |
| i | 2805 | 6.0% |
| r | 2705 | 5.8% |
| , | 2048 | 4.4% |
| d | 1613 | 3.5% |
| u | 1378 | 3.0% |
| Other values (32) | 17619 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 32986 | |
| Uppercase Letter | 8158 | 17.5% |
| Space Separator | 3344 | 7.2% |
| Other Punctuation | 2048 | 4.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 5410 | |
| o | 3536 | |
| n | 3238 | |
| e | 2840 | 8.6% |
| i | 2805 | 8.5% |
| r | 2705 | 8.2% |
| d | 1613 | 4.9% |
| u | 1378 | 4.2% |
| p | 1056 | 3.2% |
| y | 996 | 3.0% |
| Other values (12) | 7409 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1036 | |
| A | 1002 | |
| C | 826 | |
| T | 635 | 7.8% |
| J | 624 | 7.6% |
| U | 614 | 7.5% |
| B | 426 | 5.2% |
| L | 420 | 5.1% |
| P | 395 | 4.8% |
| D | 371 | 4.5% |
| Other values (8) | 1809 |
Space Separator
| Value | Count | Frequency (%) |
| 3344 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 2048 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 41144 | |
| Common | 5392 | 11.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 5410 | 13.1% |
| o | 3536 | 8.6% |
| n | 3238 | 7.9% |
| e | 2840 | 6.9% |
| i | 2805 | 6.8% |
| r | 2705 | 6.6% |
| d | 1613 | 3.9% |
| u | 1378 | 3.3% |
| p | 1056 | 2.6% |
| S | 1036 | 2.5% |
| Other values (30) | 15527 |
Common
| Value | Count | Frequency (%) |
| 3344 | ||
| , | 2048 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46536 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 5410 | 11.6% |
| o | 3536 | 7.6% |
| 3344 | 7.2% | |
| n | 3238 | 7.0% |
| e | 2840 | 6.1% |
| i | 2805 | 6.0% |
| r | 2705 | 5.8% |
| , | 2048 | 4.4% |
| d | 1613 | 3.5% |
| u | 1378 | 3.0% |
| Other values (32) | 17619 |
trans_id
Text
UNIQUE
| Distinct | 3989 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Characters and Unicode
| Total characters | 71802 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3989 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Qc9M36mAY1s6rxld9M |
|---|---|
| 2nd row | Hlrx3ReSC0IJRYzBy5 |
| 3rd row | qScFTTzOUZD3M0rcg5 |
| 4th row | 0cOkB7x1L6DB5WzKvu |
| 5th row | O7jfbyedchAWUScw30 |
| Value | Count | Frequency (%) |
| qc9m36may1s6rxld9m | 1 | < 0.1% |
| orrmctmsyrgfzyv0hn | 1 | < 0.1% |
| i6lhsbbk0g3xk5m2eu | 1 | < 0.1% |
| qscfttzouzd3m0rcg5 | 1 | < 0.1% |
| 0cokb7x1l6db5wzkvu | 1 | < 0.1% |
| o7jfbyedchawuscw30 | 1 | < 0.1% |
| cg6y9khge0enh3a6az | 1 | < 0.1% |
| ntqm2jxqsimmysqsp1 | 1 | < 0.1% |
| tetj62xq7zjwett6ia | 1 | < 0.1% |
| j3xnniyk9ww7x0zdn1 | 1 | < 0.1% |
| Other values (3979) | 3979 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 1227 | 1.7% |
| 4 | 1218 | 1.7% |
| O | 1214 | 1.7% |
| 6 | 1214 | 1.7% |
| S | 1203 | 1.7% |
| 8 | 1199 | 1.7% |
| o | 1198 | 1.7% |
| Q | 1196 | 1.7% |
| d | 1195 | 1.7% |
| 2 | 1192 | 1.7% |
| Other values (52) | 59746 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 30092 | |
| Uppercase Letter | 30000 | |
| Decimal Number | 11710 | 16.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 1227 | 4.1% |
| o | 1198 | 4.0% |
| d | 1195 | 4.0% |
| m | 1188 | 3.9% |
| h | 1183 | 3.9% |
| u | 1181 | 3.9% |
| k | 1178 | 3.9% |
| j | 1174 | 3.9% |
| v | 1172 | 3.9% |
| f | 1172 | 3.9% |
| Other values (16) | 18224 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1214 | 4.0% |
| S | 1203 | 4.0% |
| Q | 1196 | 4.0% |
| K | 1180 | 3.9% |
| W | 1179 | 3.9% |
| M | 1175 | 3.9% |
| E | 1171 | 3.9% |
| A | 1171 | 3.9% |
| B | 1170 | 3.9% |
| I | 1168 | 3.9% |
| Other values (16) | 18173 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 1218 | |
| 6 | 1214 | |
| 8 | 1199 | |
| 2 | 1192 | |
| 0 | 1169 | |
| 9 | 1163 | |
| 1 | 1162 | |
| 3 | 1160 | |
| 5 | 1136 | |
| 7 | 1097 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 60092 | |
| Common | 11710 | 16.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 1227 | 2.0% |
| O | 1214 | 2.0% |
| S | 1203 | 2.0% |
| o | 1198 | 2.0% |
| Q | 1196 | 2.0% |
| d | 1195 | 2.0% |
| m | 1188 | 2.0% |
| h | 1183 | 2.0% |
| u | 1181 | 2.0% |
| K | 1180 | 2.0% |
| Other values (42) | 48127 |
Common
| Value | Count | Frequency (%) |
| 4 | 1218 | |
| 6 | 1214 | |
| 8 | 1199 | |
| 2 | 1192 | |
| 0 | 1169 | |
| 9 | 1163 | |
| 1 | 1162 | |
| 3 | 1160 | |
| 5 | 1136 | |
| 7 | 1097 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71802 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 1227 | 1.7% |
| 4 | 1218 | 1.7% |
| O | 1214 | 1.7% |
| 6 | 1214 | 1.7% |
| S | 1203 | 1.7% |
| 8 | 1199 | 1.7% |
| o | 1198 | 1.7% |
| Q | 1196 | 1.7% |
| d | 1195 | 1.7% |
| 2 | 1192 | 1.7% |
| Other values (52) | 59746 |
UNIQUE
| Distinct | 3989 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 23934 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3989 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | L6TGCC |
|---|---|
| 2nd row | XTIUMZ |
| 3rd row | EX8G40 |
| 4th row | PWKEUM |
| 5th row | T70W7M |
| Value | Count | Frequency (%) |
| l6tgcc | 1 | < 0.1% |
| ajipac | 1 | < 0.1% |
| ltrw5f | 1 | < 0.1% |
| ex8g40 | 1 | < 0.1% |
| pwkeum | 1 | < 0.1% |
| t70w7m | 1 | < 0.1% |
| 4p6ao8 | 1 | < 0.1% |
| 5mwotx | 1 | < 0.1% |
| 2m3ybc | 1 | < 0.1% |
| 3rvjp4 | 1 | < 0.1% |
| Other values (3979) | 3979 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 724 | 3.0% |
| J | 716 | 3.0% |
| 7 | 713 | 3.0% |
| 1 | 700 | 2.9% |
| B | 699 | 2.9% |
| 9 | 689 | 2.9% |
| 6 | 683 | 2.9% |
| D | 680 | 2.8% |
| S | 680 | 2.8% |
| O | 678 | 2.8% |
| Other values (26) | 16972 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 17201 | |
| Decimal Number | 6733 | 28.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 724 | 4.2% |
| J | 716 | 4.2% |
| B | 699 | 4.1% |
| D | 680 | 4.0% |
| S | 680 | 4.0% |
| O | 678 | 3.9% |
| E | 677 | 3.9% |
| G | 674 | 3.9% |
| T | 673 | 3.9% |
| P | 671 | 3.9% |
| Other values (16) | 10329 |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 713 | |
| 1 | 700 | |
| 9 | 689 | |
| 6 | 683 | |
| 2 | 674 | |
| 5 | 669 | |
| 3 | 661 | |
| 8 | 657 | |
| 0 | 645 | |
| 4 | 642 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17201 | |
| Common | 6733 | 28.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| N | 724 | 4.2% |
| J | 716 | 4.2% |
| B | 699 | 4.1% |
| D | 680 | 4.0% |
| S | 680 | 4.0% |
| O | 678 | 3.9% |
| E | 677 | 3.9% |
| G | 674 | 3.9% |
| T | 673 | 3.9% |
| P | 671 | 3.9% |
| Other values (16) | 10329 |
Common
| Value | Count | Frequency (%) |
| 7 | 713 | |
| 1 | 700 | |
| 9 | 689 | |
| 6 | 683 | |
| 2 | 674 | |
| 5 | 669 | |
| 3 | 661 | |
| 8 | 657 | |
| 0 | 645 | |
| 4 | 642 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23934 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| N | 724 | 3.0% |
| J | 716 | 3.0% |
| 7 | 713 | 3.0% |
| 1 | 700 | 2.9% |
| B | 699 | 2.9% |
| 9 | 689 | 2.9% |
| 6 | 683 | 2.9% |
| D | 680 | 2.8% |
| S | 680 | 2.8% |
| O | 678 | 2.8% |
| Other values (26) | 16972 |
trans_loc
Categorical
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Delhi | |
|---|---|
| Lucknow | |
| Mumbai | |
| Ahmedabad | |
| Pune | |
| Other values (5) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.8540988 |
| Min length | 4 |
Characters and Unicode
| Total characters | 27341 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kolkata |
|---|---|
| 2nd row | Kolkata |
| 3rd row | Kolkata |
| 4th row | Delhi |
| 5th row | Delhi |
Common Values
| Value | Count | Frequency (%) |
| Delhi | 447 | |
| Lucknow | 447 | |
| Mumbai | 413 | |
| Ahmedabad | 410 | |
| Pune | 406 | |
| Kolkata | 385 | |
| Bangalore | 378 | |
| Jaipur | 377 | |
| Hyderabad | 372 | |
| Chennai | 354 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| delhi | 447 | |
| lucknow | 447 | |
| mumbai | 413 | |
| ahmedabad | 410 | |
| pune | 406 | |
| kolkata | 385 | |
| bangalore | 378 | |
| jaipur | 377 | |
| hyderabad | 372 | |
| chennai | 354 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | 8.7% |
| n | 1939 | 7.1% |
| u | 1643 | 6.0% |
| i | 1591 | 5.8% |
| d | 1564 | 5.7% |
| h | 1211 | 4.4% |
| l | 1210 | 4.4% |
| o | 1210 | 4.4% |
| b | 1195 | 4.4% |
| Other values (19) | 9177 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 23352 | |
| Uppercase Letter | 3989 | 14.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | |
| n | 1939 | 8.3% |
| u | 1643 | 7.0% |
| i | 1591 | 6.8% |
| d | 1564 | 6.7% |
| h | 1211 | 5.2% |
| l | 1210 | 5.2% |
| o | 1210 | 5.2% |
| b | 1195 | 5.1% |
| Other values (9) | 5188 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 447 | |
| L | 447 | |
| M | 413 | |
| A | 410 | |
| P | 406 | |
| K | 385 | |
| B | 378 | |
| J | 377 | |
| H | 372 | |
| C | 354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27341 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | 8.7% |
| n | 1939 | 7.1% |
| u | 1643 | 6.0% |
| i | 1591 | 5.8% |
| d | 1564 | 5.7% |
| h | 1211 | 4.4% |
| l | 1210 | 4.4% |
| o | 1210 | 4.4% |
| b | 1195 | 4.4% |
| Other values (19) | 9177 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27341 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4234 | |
| e | 2367 | 8.7% |
| n | 1939 | 7.1% |
| u | 1643 | 6.0% |
| i | 1591 | 5.8% |
| d | 1564 | 5.7% |
| h | 1211 | 4.4% |
| l | 1210 | 4.4% |
| o | 1210 | 4.4% |
| b | 1195 | 4.4% |
| Other values (19) | 9177 |
trans_cat
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Other | |
|---|---|
| Entertainment | |
| Grocery | |
| Dining | |
| Retail | |
| Other values (2) |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 7.4151416 |
| Min length | 5 |
Characters and Unicode
| Total characters | 29579 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Travel |
|---|---|
| 2nd row | Entertainment |
| 3rd row | Dining |
| 4th row | Retail |
| 5th row | Grocery |
Common Values
| Value | Count | Frequency (%) |
| Other | 606 | |
| Entertainment | 583 | |
| Grocery | 580 | |
| Dining | 574 | |
| Retail | 573 | |
| Travel | 543 | |
| Utilities | 530 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| other | 606 | |
| entertainment | 583 | |
| grocery | 580 | |
| dining | 574 | |
| retail | 573 | |
| travel | 543 | |
| utilities | 530 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3998 | |
| t | 3988 | |
| i | 3894 | |
| n | 2897 | |
| r | 2892 | |
| a | 1699 | 5.7% |
| l | 1646 | 5.6% |
| O | 606 | 2.0% |
| h | 606 | 2.0% |
| E | 583 | 2.0% |
| Other values (12) | 6770 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 25590 | |
| Uppercase Letter | 3989 | 13.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3998 | |
| t | 3988 | |
| i | 3894 | |
| n | 2897 | |
| r | 2892 | |
| a | 1699 | |
| l | 1646 | |
| h | 606 | 2.4% |
| m | 583 | 2.3% |
| y | 580 | 2.3% |
| Other values (5) | 2807 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 606 | |
| E | 583 | |
| G | 580 | |
| D | 574 | |
| R | 573 | |
| T | 543 | |
| U | 530 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 29579 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3998 | |
| t | 3988 | |
| i | 3894 | |
| n | 2897 | |
| r | 2892 | |
| a | 1699 | 5.7% |
| l | 1646 | 5.6% |
| O | 606 | 2.0% |
| h | 606 | 2.0% |
| E | 583 | 2.0% |
| Other values (12) | 6770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 29579 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 3998 | |
| t | 3988 | |
| i | 3894 | |
| n | 2897 | |
| r | 2892 | |
| a | 1699 | 5.7% |
| l | 1646 | 5.6% |
| O | 606 | 2.0% |
| h | 606 | 2.0% |
| E | 583 | 2.0% |
| Other values (12) | 6770 |
trans_currency
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| INR | |
|---|---|
| USD | 132 |
| Other | 123 |
| JPY | 121 |
| CAD | 116 |
| Other values (2) | 229 |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.0616696 |
| Min length | 3 |
Characters and Unicode
| Total characters | 12213 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | INR |
|---|---|
| 2nd row | INR |
| 3rd row | CAD |
| 4th row | INR |
| 5th row | INR |
Common Values
| Value | Count | Frequency (%) |
| INR | 3268 | |
| USD | 132 | 3.3% |
| Other | 123 | 3.1% |
| JPY | 121 | 3.0% |
| CAD | 116 | 2.9% |
| EUR | 116 | 2.9% |
| AUD | 113 | 2.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| inr | 3268 | |
| usd | 132 | 3.3% |
| other | 123 | 3.1% |
| jpy | 121 | 3.0% |
| cad | 116 | 2.9% |
| eur | 116 | 2.9% |
| aud | 113 | 2.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 3384 | |
| I | 3268 | |
| N | 3268 | |
| U | 361 | 3.0% |
| D | 361 | 3.0% |
| A | 229 | 1.9% |
| S | 132 | 1.1% |
| e | 123 | 1.0% |
| r | 123 | 1.0% |
| h | 123 | 1.0% |
| Other values (7) | 841 | 6.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11721 | |
| Lowercase Letter | 492 | 4.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 3384 | |
| I | 3268 | |
| N | 3268 | |
| U | 361 | 3.1% |
| D | 361 | 3.1% |
| A | 229 | 2.0% |
| S | 132 | 1.1% |
| O | 123 | 1.0% |
| J | 121 | 1.0% |
| P | 121 | 1.0% |
| Other values (3) | 353 | 3.0% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 123 | |
| r | 123 | |
| h | 123 | |
| t | 123 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12213 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 3384 | |
| I | 3268 | |
| N | 3268 | |
| U | 361 | 3.0% |
| D | 361 | 3.0% |
| A | 229 | 1.9% |
| S | 132 | 1.1% |
| e | 123 | 1.0% |
| r | 123 | 1.0% |
| h | 123 | 1.0% |
| Other values (7) | 841 | 6.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12213 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 3384 | |
| I | 3268 | |
| N | 3268 | |
| U | 361 | 3.0% |
| D | 361 | 3.0% |
| A | 229 | 1.9% |
| S | 132 | 1.1% |
| e | 123 | 1.0% |
| r | 123 | 1.0% |
| h | 123 | 1.0% |
| Other values (7) | 841 | 6.9% |
mcc
Real number (ℝ)
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4008.6007 |
| Minimum | 4000 |
|---|---|
| Maximum | 4019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.3 KiB |
Quantile statistics
| Minimum | 4000 |
|---|---|
| 5-th percentile | 4000 |
| Q1 | 4004 |
| median | 4008 |
| Q3 | 4013 |
| 95-th percentile | 4018 |
| Maximum | 4019 |
| Range | 19 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.6662181 |
|---|---|
| Coefficient of variation (CV) | 0.0014135152 |
| Kurtosis | -1.1813784 |
| Mean | 4008.6007 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.16950742 |
| Sum | 15990308 |
| Variance | 32.106028 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 4004 | 322 | 8.1% |
| 4003 | 316 | 7.9% |
| 4017 | 313 | 7.8% |
| 4008 | 303 | 7.6% |
| 4018 | 277 | 6.9% |
| 4000 | 272 | 6.8% |
| 4001 | 245 | 6.1% |
| 4013 | 234 | 5.9% |
| 4011 | 233 | 5.8% |
| 4006 | 211 | 5.3% |
| Other values (10) | 1263 |
| Value | Count | Frequency (%) |
| 4000 | 272 | |
| 4001 | 245 | |
| 4002 | 107 | 2.7% |
| 4003 | 316 | |
| 4004 | 322 | |
| 4005 | 211 | |
| 4006 | 211 | |
| 4007 | 69 | 1.7% |
| 4008 | 303 | |
| 4009 | 176 |
| Value | Count | Frequency (%) |
| 4019 | 3 | 0.1% |
| 4018 | 277 | |
| 4017 | 313 | |
| 4016 | 153 | |
| 4015 | 22 | 0.6% |
| 4014 | 106 | 2.7% |
| 4013 | 234 | |
| 4012 | 205 | |
| 4011 | 233 | |
| 4010 | 211 |
trans_amount
Real number (ℝ)
HIGH CORRELATION
| Distinct | 3295 |
|---|---|
| Distinct (%) | 82.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10926.308 |
| Minimum | 1.01 |
|---|---|
| Maximum | 49983.621 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.3 KiB |
Quantile statistics
| Minimum | 1.01 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 41 |
| median | 2366.77 |
| Q3 | 19563 |
| 95-th percentile | 44238.835 |
| Maximum | 49983.621 |
| Range | 49982.611 |
| Interquartile range (IQR) | 19522 |
Descriptive statistics
| Standard deviation | 15157.537 |
|---|---|
| Coefficient of variation (CV) | 1.3872515 |
| Kurtosis | 0.044927071 |
| Mean | 10926.308 |
| Median Absolute Deviation (MAD) | 2344.77 |
| Skewness | 1.2269281 |
| Sum | 43585042 |
| Variance | 2.2975094 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50 | 21 | 0.5% |
| 12 | 20 | 0.5% |
| 41 | 20 | 0.5% |
| 47 | 19 | 0.5% |
| 10 | 18 | 0.5% |
| 33 | 18 | 0.5% |
| 9 | 17 | 0.4% |
| 4 | 17 | 0.4% |
| 37 | 16 | 0.4% |
| 46 | 16 | 0.4% |
| Other values (3285) | 3807 |
| Value | Count | Frequency (%) |
| 1.00999999 | 1 | |
| 1.059999943 | 1 | |
| 1.070000052 | 1 | |
| 1.220000029 | 1 | |
| 1.460000038 | 1 | |
| 1.710000038 | 1 | |
| 1.720000029 | 1 | |
| 1.75 | 1 | |
| 1.789999962 | 1 | |
| 1.879999995 | 1 |
| Value | Count | Frequency (%) |
| 49983.62109 | 1 | |
| 49875 | 1 | |
| 49862 | 1 | |
| 49828 | 1 | |
| 49795.46094 | 1 | |
| 49781 | 1 | |
| 49710 | 1 | |
| 49696 | 1 | |
| 49691 | 1 | |
| 49676.44922 | 1 |
trans_date
Date
| Distinct | 3987 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Minimum | 2023-08-10 05:56:41 |
|---|---|
| Maximum | 2023-09-09 05:52:02 |
Histogram with fixed size bins (bins=50)
trans_payment_method
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Credit Card | |
|---|---|
| Debit Card |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.500877 |
| Min length | 10 |
Characters and Unicode
| Total characters | 41888 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Debit Card |
|---|---|
| 2nd row | Credit Card |
| 3rd row | Debit Card |
| 4th row | Credit Card |
| 5th row | Credit Card |
Common Values
| Value | Count | Frequency (%) |
| Credit Card | 1998 | |
| Debit Card | 1991 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| card | 3989 | |
| credit | 1998 | |
| debit | 1991 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 5987 | |
| r | 5987 | |
| d | 5987 | |
| e | 3989 | |
| i | 3989 | |
| t | 3989 | |
| 3989 | ||
| a | 3989 | |
| D | 1991 | 4.8% |
| b | 1991 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 29921 | |
| Uppercase Letter | 7978 | 19.0% |
| Space Separator | 3989 | 9.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 5987 | |
| d | 5987 | |
| e | 3989 | |
| i | 3989 | |
| t | 3989 | |
| a | 3989 | |
| b | 1991 | 6.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 5987 | |
| D | 1991 | 25.0% |
Space Separator
| Value | Count | Frequency (%) |
| 3989 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 37899 | |
| Common | 3989 | 9.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 5987 | |
| r | 5987 | |
| d | 5987 | |
| e | 3989 | |
| i | 3989 | |
| t | 3989 | |
| a | 3989 | |
| D | 1991 | 5.3% |
| b | 1991 | 5.3% |
Common
| Value | Count | Frequency (%) |
| 3989 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 41888 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 5987 | |
| r | 5987 | |
| d | 5987 | |
| e | 3989 | |
| i | 3989 | |
| t | 3989 | |
| 3989 | ||
| a | 3989 | |
| D | 1991 | 4.8% |
| b | 1991 | 4.8% |
trans_verify_method
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| PIN | |
|---|---|
| Biometric |
Length
| Max length | 9 |
|---|---|
| Median length | 3 |
| Mean length | 5.9902231 |
| Min length | 3 |
Characters and Unicode
| Total characters | 23895 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Biometric |
|---|---|
| 2nd row | Biometric |
| 3rd row | PIN |
| 4th row | Biometric |
| 5th row | Biometric |
Common Values
| Value | Count | Frequency (%) |
| PIN | 2001 | |
| Biometric | 1988 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pin | 2001 | |
| biometric | 1988 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 3976 | |
| P | 2001 | |
| I | 2001 | |
| N | 2001 | |
| B | 1988 | |
| o | 1988 | |
| m | 1988 | |
| e | 1988 | |
| t | 1988 | |
| r | 1988 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15904 | |
| Uppercase Letter | 7991 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 3976 | |
| o | 1988 | |
| m | 1988 | |
| e | 1988 | |
| t | 1988 | |
| r | 1988 | |
| c | 1988 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2001 | |
| I | 2001 | |
| N | 2001 | |
| B | 1988 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23895 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 3976 | |
| P | 2001 | |
| I | 2001 | |
| N | 2001 | |
| B | 1988 | |
| o | 1988 | |
| m | 1988 | |
| e | 1988 | |
| t | 1988 | |
| r | 1988 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23895 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 3976 | |
| P | 2001 | |
| I | 2001 | |
| N | 2001 | |
| B | 1988 | |
| o | 1988 | |
| m | 1988 | |
| e | 1988 | |
| t | 1988 | |
| r | 1988 |
trans_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.3 KiB |
| Payment | |
|---|---|
| Transfer | |
| Purchase |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.6580597 |
| Min length | 7 |
Characters and Unicode
| Total characters | 30548 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Payment |
|---|---|
| 2nd row | Payment |
| 3rd row | Transfer |
| 4th row | Payment |
| 5th row | Transfer |
Common Values
| Value | Count | Frequency (%) |
| Payment | 1364 | |
| Transfer | 1334 | |
| Purchase | 1291 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| payment | 1364 | |
| transfer | 1334 | |
| purchase | 1291 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3989 | |
| e | 3989 | |
| r | 3959 | |
| n | 2698 | |
| P | 2655 | |
| s | 2625 | |
| y | 1364 | 4.5% |
| m | 1364 | 4.5% |
| t | 1364 | 4.5% |
| T | 1334 | 4.4% |
| Other values (4) | 5207 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 26559 | |
| Uppercase Letter | 3989 | 13.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3989 | |
| e | 3989 | |
| r | 3959 | |
| n | 2698 | |
| s | 2625 | |
| y | 1364 | 5.1% |
| m | 1364 | 5.1% |
| t | 1364 | 5.1% |
| f | 1334 | 5.0% |
| u | 1291 | 4.9% |
| Other values (2) | 2582 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2655 | |
| T | 1334 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 30548 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3989 | |
| e | 3989 | |
| r | 3959 | |
| n | 2698 | |
| P | 2655 | |
| s | 2625 | |
| y | 1364 | 4.5% |
| m | 1364 | 4.5% |
| t | 1364 | 4.5% |
| T | 1334 | 4.4% |
| Other values (4) | 5207 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30548 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 3989 | |
| e | 3989 | |
| r | 3959 | |
| n | 2698 | |
| P | 2655 | |
| s | 2625 | |
| y | 1364 | 4.5% |
| m | 1364 | 4.5% |
| t | 1364 | 4.5% |
| T | 1334 | 4.4% |
| Other values (4) | 5207 |
fake
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 2512 | |
| True | 1477 |
| card_number | customer_age | mcc | trans_amount | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_loc | trans_cat | trans_currency | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| card_number | 1.000 | -0.030 | -0.018 | 0.002 | 0.866 | 0.866 | 0.867 | 0.074 | 0.035 | 0.867 | 0.044 | 0.086 | 0.000 | 0.117 | 0.099 | 0.000 |
| customer_age | -0.030 | 1.000 | 0.025 | -0.016 | 0.092 | 0.103 | 0.083 | 0.016 | 0.028 | 0.083 | 0.038 | 0.025 | 0.042 | 0.000 | 0.032 | 0.000 |
| mcc | -0.018 | 0.025 | 1.000 | 0.016 | 0.000 | 0.016 | 0.000 | 0.000 | 0.027 | 0.000 | 0.025 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 |
| trans_amount | 0.002 | -0.016 | 0.016 | 1.000 | 0.000 | 0.000 | 0.000 | 0.216 | 0.000 | 0.000 | 0.000 | 0.253 | 0.000 | 0.030 | 0.022 | 0.999 |
| customer_segment | 0.866 | 0.092 | 0.000 | 0.000 | 1.000 | 0.050 | 0.075 | 0.000 | 0.024 | 0.075 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| card_type | 0.866 | 0.103 | 0.016 | 0.000 | 0.050 | 1.000 | 0.084 | 0.031 | 0.000 | 0.084 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| customer_location | 0.867 | 0.083 | 0.000 | 0.000 | 0.075 | 0.084 | 1.000 | 0.010 | 0.000 | 1.000 | 0.000 | 0.016 | 0.015 | 0.000 | 0.035 | 0.000 |
| merchant_name | 0.074 | 0.016 | 0.000 | 0.216 | 0.000 | 0.031 | 0.010 | 1.000 | 0.000 | 0.010 | 0.000 | 0.176 | 0.000 | 0.035 | 0.020 | 0.619 |
| merchant_location | 0.035 | 0.028 | 0.027 | 0.000 | 0.024 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| trans_loc | 0.867 | 0.083 | 0.000 | 0.000 | 0.075 | 0.084 | 1.000 | 0.010 | 0.000 | 1.000 | 0.000 | 0.016 | 0.015 | 0.000 | 0.035 | 0.000 |
| trans_cat | 0.044 | 0.038 | 0.025 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| trans_currency | 0.086 | 0.025 | 0.000 | 0.253 | 0.000 | 0.000 | 0.016 | 0.176 | 0.000 | 0.016 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.611 |
| trans_payment_method | 0.000 | 0.042 | 0.000 | 0.000 | 0.000 | 0.000 | 0.015 | 0.000 | 0.000 | 0.015 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 |
| trans_verify_method | 0.117 | 0.000 | 0.000 | 0.030 | 0.000 | 0.000 | 0.000 | 0.035 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.024 | 0.000 |
| trans_status | 0.099 | 0.032 | 0.000 | 0.022 | 0.000 | 0.000 | 0.035 | 0.020 | 0.000 | 0.035 | 0.000 | 0.000 | 0.000 | 0.024 | 1.000 | 0.000 |
| fake | 0.000 | 0.000 | 0.004 | 0.999 | 0.000 | 0.000 | 0.000 | 0.619 | 0.000 | 0.000 | 0.000 | 0.611 | 0.000 | 0.000 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| cardholder_name | card_number | customer_age | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_id | trans_approval_code | trans_loc | trans_cat | trans_currency | mcc | trans_amount | trans_date | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Eric Scott | 697928097444 | 49 | Retail | Other | Kolkata | airtel | Tokyo, Japan | Qc9M36mAY1s6rxld9M | L6TGCC | Kolkata | Travel | INR | 4013 | 31.730000 | 2023-08-18 08:17:12 | Debit Card | Biometric | Payment | False |
| 1 | Eric Scott | 697928097444 | 49 | Retail | Other | Kolkata | airtel | Cape Town, South Africa | Hlrx3ReSC0IJRYzBy5 | XTIUMZ | Kolkata | Entertainment | INR | 4017 | 1358.260010 | 2023-08-28 12:16:07 | Credit Card | Biometric | Payment | False |
| 2 | Eric Scott | 697928097444 | 49 | Retail | Other | Kolkata | fake_merchant_8 | New York City, USA | qScFTTzOUZD3M0rcg5 | EX8G40 | Kolkata | Dining | CAD | 4007 | 7453.270020 | 2023-09-03 00:55:30 | Debit Card | PIN | Transfer | True |
| 3 | Jason Jacobs | 357500497046 | 55 | Student | Visa | Delhi | rakuten | Chennai | 0cOkB7x1L6DB5WzKvu | PWKEUM | Delhi | Retail | INR | 4010 | 2781.909912 | 2023-08-16 04:00:04 | Credit Card | Biometric | Payment | False |
| 4 | Jason Jacobs | 357500497046 | 55 | Student | Visa | Delhi | swiggy | Chennai | O7jfbyedchAWUScw30 | T70W7M | Delhi | Grocery | INR | 4018 | 39.000000 | 2023-09-02 15:01:38 | Credit Card | Biometric | Transfer | False |
| 5 | Jason Jacobs | 357500497046 | 55 | Student | Visa | Delhi | chai talks | Dubai, UAE | cg6Y9kHGe0ENh3a6Az | 4P6AO8 | Delhi | Retail | USD | 4016 | 35631.968750 | 2023-09-02 15:02:08 | Credit Card | Biometric | Payment | True |
| 6 | Heather Lewis | 263191058753 | 36 | Student | American Express | Bangalore | zomato | Jaipur | ntqm2jxQsiMmYsQSp1 | 5MWOTX | Bangalore | Retail | INR | 4017 | 10.000000 | 2023-08-10 11:25:14 | Credit Card | Biometric | Payment | False |
| 7 | Heather Lewis | 263191058753 | 36 | Student | American Express | Bangalore | amazon gift cards | Cape Town, South Africa | TETj62XQ7zJWeTt6iA | 2M3YBC | Bangalore | Retail | INR | 4002 | 1980.000000 | 2023-08-15 14:43:18 | Credit Card | PIN | Transfer | False |
| 8 | Heather Lewis | 263191058753 | 36 | Student | American Express | Bangalore | instamart | Singapore, Singapore | j3xnNiyK9WW7X0ZDn1 | 3RVJP4 | Bangalore | Retail | INR | 4013 | 2141.000000 | 2023-08-23 13:14:19 | Credit Card | PIN | Payment | False |
| 9 | Heather Lewis | 263191058753 | 36 | Student | American Express | Bangalore | rakuten | New York City, USA | BKDVY2pQ4lyAo61Q28 | NFMS2N | Bangalore | Other | INR | 4000 | 21.120001 | 2023-09-01 09:19:27 | Debit Card | Biometric | Transfer | False |
| cardholder_name | card_number | customer_age | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_id | trans_approval_code | trans_loc | trans_cat | trans_currency | mcc | trans_amount | trans_date | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3979 | Kevin West | 800746486423 | 68 | Student | American Express | Ahmedabad | rakuten | Ahmedabad | ZRfTRK6WDs2vC76vcU | 01LO9G | Ahmedabad | Entertainment | INR | 4011 | 12.110000 | 2023-08-13 03:22:30 | Debit Card | Biometric | Transfer | False |
| 3980 | Kevin West | 800746486423 | 68 | Student | American Express | Ahmedabad | airtel | Kolkata | gRhP8HMoK9zbFxFje2 | 0ENJET | Ahmedabad | Grocery | INR | 4018 | 1296.359985 | 2023-08-13 07:07:02 | Debit Card | PIN | Payment | False |
| 3981 | Kevin West | 800746486423 | 68 | Student | American Express | Ahmedabad | rakuten | London, UK | TNfO996g9nXQRrVZil | FAP42S | Ahmedabad | Other | INR | 4016 | 45.470001 | 2023-08-15 02:10:33 | Debit Card | Biometric | Purchase | False |
| 3982 | Kevin West | 800746486423 | 68 | Student | American Express | Ahmedabad | rakuten | Cape Town, South Africa | RV9VxUPx46TKGRR0hX | GGP97J | Ahmedabad | Grocery | INR | 4017 | 727.960022 | 2023-09-08 21:57:31 | Credit Card | Biometric | Payment | False |
| 3983 | Kevin West | 800746486423 | 68 | Student | American Express | Ahmedabad | fake_merchant_1 | London, UK | EWbU2kaxw2ayQNcON1 | VCYUXQ | Ahmedabad | Utilities | JPY | 4016 | 38564.000000 | 2023-09-08 21:57:56 | Debit Card | PIN | Purchase | True |
| 3984 | Jennifer Walters | 220361958390 | 21 | Premium | Visa | Pune | rakuten | Paris, France | PbCYi8tK618jq6oLvR | 0SIT2Y | Pune | Dining | INR | 4009 | 38.070000 | 2023-08-12 10:49:35 | Credit Card | PIN | Purchase | False |
| 3985 | Jennifer Walters | 220361958390 | 21 | Premium | Visa | Pune | instamart | Hyderabad | uf8bySvRheHRdqbhMf | BNNAJP | Pune | Dining | INR | 4015 | 227.809998 | 2023-08-18 15:53:11 | Debit Card | PIN | Purchase | False |
| 3986 | Jennifer Walters | 220361958390 | 21 | Premium | Visa | Pune | instamart | Rio de Janeiro, Brazil | vR2AoeftxNSunTyUel | 8FI4S6 | Pune | Retail | INR | 4013 | 30.000000 | 2023-08-31 12:35:52 | Debit Card | Biometric | Purchase | False |
| 3987 | Jennifer Walters | 220361958390 | 21 | Premium | Visa | Pune | rakuten | Hyderabad | AOV2MnXgSNebfQard9 | LSDJX9 | Pune | Travel | INR | 4011 | 30.000000 | 2023-09-02 15:03:02 | Credit Card | Biometric | Purchase | False |
| 3988 | Jennifer Walters | 220361958390 | 21 | Premium | Visa | Pune | swiggy | Chennai | NC9WbXNykaSJNywAN4 | 49ULH0 | Pune | Entertainment | INR | 4000 | 37079.480469 | 2023-09-02 16:51:07 | Debit Card | PIN | Purchase | True |